{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "list_xy = ['02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','20','21','22','23','24','25','32']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url_xy = r'http://202.114.224.81:7777/pls/wwwbks/teacherinfo.inputxsh'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "req_xy = requests.get(url_xy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "req_xy.encoding = 'gbk'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import lxml"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(req_xy.text,'lxml')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "学院对应编号收集完毕！\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'02': '经济学院',\n",
       " '03': '金融学院',\n",
       " '04': '法学院',\n",
       " '05': '刑事学院',\n",
       " '06': '工商学院',\n",
       " '07': '财税学院',\n",
       " '08': '会计学院',\n",
       " '09': '统计学院',\n",
       " '10': '公管学院',\n",
       " '11': '外语学院',\n",
       " '12': '新闻学院',\n",
       " '13': '工程学院',\n",
       " '14': '哲学院',\n",
       " '15': '体育部',\n",
       " '16': '图书馆',\n",
       " '20': '人武部',\n",
       " '21': '就业指导中心',\n",
       " '22': '学工部',\n",
       " '23': '国际教育学院',\n",
       " '24': '马克思主义学院',\n",
       " '25': '中韩学院',\n",
       " '32': '文澜学院'}"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "option_xy = soup.find_all('option')\n",
    "def get_xy(option_xy):\n",
    "    dict_xy = {}\n",
    "    for x in option_xy:\n",
    "        if len(x['value']) <= 5:\n",
    "            dict_xy[x['value']] = x.contents[0]\n",
    "    print('学院对应编号收集完毕！')\n",
    "    return dict_xy\n",
    "xy_bh = get_xy(option_xy)       #获取学院编号以及对应学院名称"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['1', 'Z0000655', '艾  华', '07', '财政税务学院', '男', ''],\n",
       " ['2', 'Z0003926', '白志远', '07', '财政税务学院', '男', ''],\n",
       " ['3', 'Z0004288', '陈思霞', '07', '财政税务学院', '', ''],\n",
       " ['4', 'Z0000629', '陈志勇', '07', '财政税务学院', '男', ''],\n",
       " ['5', 'Z0000664', '程\\u3000黎', '07', '财政税务学院', '女', ''],\n",
       " ['6', 'Z0000661', '范信葵', '07', '财政税务学院', '女', ''],\n",
       " ['7', 'Z0000651', '甘行琼', '07', '财政税务学院', '女', ''],\n",
       " ['8', 'Z0000658', '高亚军', '07', '财政税务学院', '女', ''],\n",
       " ['9', 'Z0000662', '高正章', '07', '财政税务学院', '男', ''],\n",
       " ['10', 'Z0000665', '郭月梅', '07', '财政税务学院', '女', ''],\n",
       " ['11', 'Z0000663', '侯石安', '07', '财政税务学院', '男', ''],\n",
       " ['12', 'Z0004512', '胡海燕', '07', '财政税务学院', '', ''],\n",
       " ['13', 'Z0003554', '胡洪曙', '07', '财政税务学院', '', ''],\n",
       " ['14', 'Z0003935', '解洪涛', '07', '财政税务学院', '男', ''],\n",
       " ['15', 'Z0003718', '金荣学', '07', '财政税务学院', '男', ''],\n",
       " ['16', 'Z0000660', '李  波', '07', '财政税务学院', '男', ''],\n",
       " ['17', 'Z0000647', '李  农', '07', '财政税务学院', '女', ''],\n",
       " ['18', 'Z0000642', '李景友', '07', '财政税务学院', '男', ''],\n",
       " ['19', 'Z0004161', '李琳', '07', '财政税务学院', '', ''],\n",
       " ['20', 'Z0000653', '李祥云', '07', '财政税务学院', '男', ''],\n",
       " ['21', 'Z0000641', '刘京焕', '07', '财政税务学院', '男', ''],\n",
       " ['22', 'Z0000657', '刘孝诚', '07', '财政税务学院', '男', ''],\n",
       " ['23', 'Z0004201', '鲁元平', '07', '财政税务学院', '', ''],\n",
       " ['24', 'Z0000648', '毛  晖', '07', '财政税务学院', '女', ''],\n",
       " ['25', 'Z0000669', '梅建明', '07', '财政税务学院', '男', ''],\n",
       " ['26', 'Z0000654', '庞凤喜', '07', '财政税务学院', '女', ''],\n",
       " ['27', 'Z0004534', '彭浪川', '07', '财政税务学院', '', ''],\n",
       " ['28', 'Z0004447', '祁  毓', '07', '财政税务学院', '', ''],\n",
       " ['29', 'Z0003577', '孙  静', '07', '财政税务学院', '女', ''],\n",
       " ['30', 'Z0001518', '孙群力', '07', '财政税务学院', '男', ''],\n",
       " ['31', 'Z0004363', '田彬彬', '07', '财政税务学院', '', ''],\n",
       " ['32', 'Z0003571', '王  敏', '07', '财政税务学院', '女', ''],\n",
       " ['33', 'Z0004176', '王宝顺', '07', '财政税务学院', '男', ''],\n",
       " ['34', 'Z0000643', '王金秀', '07', '财政税务学院', '女', ''],\n",
       " ['35', 'Z0000650', '王银梅', '07', '财政税务学院', '女', ''],\n",
       " ['36', 'Z0004172', '魏福成', '07', '财政税务学院', '', ''],\n",
       " ['37', 'Z0000649', '肖  准', '07', '财政税务学院', '男', ''],\n",
       " ['38', 'Z0000659', '薛  钢', '07', '财政税务学院', '男', ''],\n",
       " ['39', 'Z0000626', '杨灿明', '07', '财政税务学院', '男', ''],\n",
       " ['40', 'Z0003726', '俞  杰', '07', '财政税务学院', '男', ''],\n",
       " ['41', 'Z0004257', '詹新宇', '07', '财政税务学院', '', ''],\n",
       " ['42', 'Z0000666', '张\\u3000青', '07', '财政税务学院', '男', ''],\n",
       " ['43', 'Z0003768', '张朝举', '07', '财政税务学院', '', ''],\n",
       " ['44', 'Z0004460', '赵  颖', '07', '财政税务学院', '', ''],\n",
       " ['45', 'Z0003510', '赵兴罗', '07', '财政税务学院', '女', ''],\n",
       " ['46', 'Z0003468', '周春英', '07', '财政税务学院', '女', ''],\n",
       " ['47', 'Z0004034', '庄佳强', '07', '财政税务学院', '男', ''],\n",
       " ['48', 'Z0004142', '亓寿伟', '07', '财政税务学院', '男', ''],\n",
       " []]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dic = {'vg_xsh':'07'}\n",
    "url_idenf = r'http://202.114.224.81:7777/pls/wwwbks/teacherinfo.choiceteacher'\n",
    "req_ident = requests.post(url_idenf,params=dic)\n",
    "req_ident.encoding = 'gbk'\n",
    "Soup_ident = BeautifulSoup(req_ident.text,'lxml')\n",
    "tea_table = Soup_ident.find_all('table')[4]\n",
    "lst_tea = tea_table.getText().strip('\\n').split('&nbsp')\n",
    "result = []\n",
    "answer = []\n",
    "for tea in range(1,len(lst_tea)):\n",
    "        ree = lst_tea[tea].split('\\n')[1:]\n",
    "        answer.append(ree)\n",
    "title = lst_tea[0].split('\\n')[:7]\n",
    "person_one = lst_tea[0].split('\\n')[8:]\n",
    "result.append(person_one)\n",
    "result = result + answer\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>教师号</th>\n",
       "      <th>教师名</th>\n",
       "      <th>系所号</th>\n",
       "      <th>系所名</th>\n",
       "      <th>性别</th>\n",
       "      <th>备注</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Z0000655</td>\n",
       "      <td>艾  华</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Z0003926</td>\n",
       "      <td>白志远</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Z0004288</td>\n",
       "      <td>陈思霞</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Z0000629</td>\n",
       "      <td>陈志勇</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Z0000664</td>\n",
       "      <td>程　黎</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Z0000661</td>\n",
       "      <td>范信葵</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Z0000651</td>\n",
       "      <td>甘行琼</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Z0000658</td>\n",
       "      <td>高亚军</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Z0000662</td>\n",
       "      <td>高正章</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Z0000665</td>\n",
       "      <td>郭月梅</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Z0000663</td>\n",
       "      <td>侯石安</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Z0004512</td>\n",
       "      <td>胡海燕</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Z0003554</td>\n",
       "      <td>胡洪曙</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Z0003935</td>\n",
       "      <td>解洪涛</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Z0003718</td>\n",
       "      <td>金荣学</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Z0000660</td>\n",
       "      <td>李  波</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Z0000647</td>\n",
       "      <td>李  农</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Z0000642</td>\n",
       "      <td>李景友</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Z0004161</td>\n",
       "      <td>李琳</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Z0000653</td>\n",
       "      <td>李祥云</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Z0000641</td>\n",
       "      <td>刘京焕</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Z0000657</td>\n",
       "      <td>刘孝诚</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Z0004201</td>\n",
       "      <td>鲁元平</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Z0000648</td>\n",
       "      <td>毛  晖</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Z0000669</td>\n",
       "      <td>梅建明</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Z0000654</td>\n",
       "      <td>庞凤喜</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Z0004534</td>\n",
       "      <td>彭浪川</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Z0004447</td>\n",
       "      <td>祁  毓</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Z0003577</td>\n",
       "      <td>孙  静</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Z0001518</td>\n",
       "      <td>孙群力</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>Z0004363</td>\n",
       "      <td>田彬彬</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>Z0003571</td>\n",
       "      <td>王  敏</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>Z0004176</td>\n",
       "      <td>王宝顺</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>Z0000643</td>\n",
       "      <td>王金秀</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>Z0000650</td>\n",
       "      <td>王银梅</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>Z0004172</td>\n",
       "      <td>魏福成</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>Z0000649</td>\n",
       "      <td>肖  准</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>Z0000659</td>\n",
       "      <td>薛  钢</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>Z0000626</td>\n",
       "      <td>杨灿明</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>Z0003726</td>\n",
       "      <td>俞  杰</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>Z0004257</td>\n",
       "      <td>詹新宇</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>Z0000666</td>\n",
       "      <td>张　青</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>Z0003768</td>\n",
       "      <td>张朝举</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>Z0004460</td>\n",
       "      <td>赵  颖</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>Z0003510</td>\n",
       "      <td>赵兴罗</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>Z0003468</td>\n",
       "      <td>周春英</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>女</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>Z0004034</td>\n",
       "      <td>庄佳强</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>Z0004142</td>\n",
       "      <td>亓寿伟</td>\n",
       "      <td>07</td>\n",
       "      <td>财政税务学院</td>\n",
       "      <td>男</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      序号       教师号   教师名   系所号     系所名    性别    备注\n",
       "0      1  Z0000655  艾  华    07  财政税务学院     男      \n",
       "1      2  Z0003926   白志远    07  财政税务学院     男      \n",
       "2      3  Z0004288   陈思霞    07  财政税务学院            \n",
       "3      4  Z0000629   陈志勇    07  财政税务学院     男      \n",
       "4      5  Z0000664   程　黎    07  财政税务学院     女      \n",
       "5      6  Z0000661   范信葵    07  财政税务学院     女      \n",
       "6      7  Z0000651   甘行琼    07  财政税务学院     女      \n",
       "7      8  Z0000658   高亚军    07  财政税务学院     女      \n",
       "8      9  Z0000662   高正章    07  财政税务学院     男      \n",
       "9     10  Z0000665   郭月梅    07  财政税务学院     女      \n",
       "10    11  Z0000663   侯石安    07  财政税务学院     男      \n",
       "11    12  Z0004512   胡海燕    07  财政税务学院            \n",
       "12    13  Z0003554   胡洪曙    07  财政税务学院            \n",
       "13    14  Z0003935   解洪涛    07  财政税务学院     男      \n",
       "14    15  Z0003718   金荣学    07  财政税务学院     男      \n",
       "15    16  Z0000660  李  波    07  财政税务学院     男      \n",
       "16    17  Z0000647  李  农    07  财政税务学院     女      \n",
       "17    18  Z0000642   李景友    07  财政税务学院     男      \n",
       "18    19  Z0004161    李琳    07  财政税务学院            \n",
       "19    20  Z0000653   李祥云    07  财政税务学院     男      \n",
       "20    21  Z0000641   刘京焕    07  财政税务学院     男      \n",
       "21    22  Z0000657   刘孝诚    07  财政税务学院     男      \n",
       "22    23  Z0004201   鲁元平    07  财政税务学院            \n",
       "23    24  Z0000648  毛  晖    07  财政税务学院     女      \n",
       "24    25  Z0000669   梅建明    07  财政税务学院     男      \n",
       "25    26  Z0000654   庞凤喜    07  财政税务学院     女      \n",
       "26    27  Z0004534   彭浪川    07  财政税务学院            \n",
       "27    28  Z0004447  祁  毓    07  财政税务学院            \n",
       "28    29  Z0003577  孙  静    07  财政税务学院     女      \n",
       "29    30  Z0001518   孙群力    07  财政税务学院     男      \n",
       "30    31  Z0004363   田彬彬    07  财政税务学院            \n",
       "31    32  Z0003571  王  敏    07  财政税务学院     女      \n",
       "32    33  Z0004176   王宝顺    07  财政税务学院     男      \n",
       "33    34  Z0000643   王金秀    07  财政税务学院     女      \n",
       "34    35  Z0000650   王银梅    07  财政税务学院     女      \n",
       "35    36  Z0004172   魏福成    07  财政税务学院            \n",
       "36    37  Z0000649  肖  准    07  财政税务学院     男      \n",
       "37    38  Z0000659  薛  钢    07  财政税务学院     男      \n",
       "38    39  Z0000626   杨灿明    07  财政税务学院     男      \n",
       "39    40  Z0003726  俞  杰    07  财政税务学院     男      \n",
       "40    41  Z0004257   詹新宇    07  财政税务学院            \n",
       "41    42  Z0000666   张　青    07  财政税务学院     男      \n",
       "42    43  Z0003768   张朝举    07  财政税务学院            \n",
       "43    44  Z0004460  赵  颖    07  财政税务学院            \n",
       "44    45  Z0003510   赵兴罗    07  财政税务学院     女      \n",
       "45    46  Z0003468   周春英    07  财政税务学院     女      \n",
       "46    47  Z0004034   庄佳强    07  财政税务学院     男      \n",
       "47    48  Z0004142   亓寿伟    07  财政税务学院     男      \n",
       "48  None      None  None  None    None  None  None"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(result,columns = title)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'numpy.ndarray' object has no attribute 'items'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-131-8dcaec08603d>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0marray\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m: 'numpy.ndarray' object has no attribute 'items'"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}
